for i in user_info
do
/opt/module/sqoop/bin/sqoop import --connect jdbc:mysql://node101:3306/wyysj  \
    --username root  --password 123456 \
    --delete-target-dir \
    -m 1 \
    --table $i \
    --target-dir /warehouse/ads_basic/wyysj/$i/2025-07-25 \
    -z \
    --compression-codec gzip \
    --null-string '\\N' --null-non-string '\\N' \
    --fields-terminated-by '\t' --lines-terminated-by '\n'
done



sqoop import \
--connect jdbc:mysql://node101:3306/wyysj \
--username root \
--password 123456 \
--as-textfile \
--query 'SELECT id, name, price FROM jtp_ads.product WHERE $CONDITIONS AND 1=1;' \
--delete-target-dir \
--target-dir "hdfs://node101:8020/warehouse/ads_basic/product/2024-10-01" \
--fields-terminated-by '\001' \
--num-mappers 1 \
--null-string '\\N' \
--null-non-string '\\N'
